Hands-On Lab
Introduction to SQL Azure
Lab version:2.0.0
Last updated:9/19/2011
Contents
Overview
Exercise 1: Preparing Your SQL Azure Account
Task 1 – Retrieving your SQL Azure Server Name
Exercise 2: Working with Data Basic DDL and DML
Task 1 – Creating a New Database
Task 2 – Managing your Database with the Database Manager for SQL Azure
Task 3 – Managing your Database with SQL Server Management Studio
Task 4 – Creating Logins and Database Users
Task 5 – Creating Tables, Indices, and Queries
Exercise 3: Build a Windows Azure Application that Accesses SQL Azure
Task 1 – Loading the Sample Database into SQL Azure
Task 2 – Creating the Visual Studio Project
Exercise 4: Connecting via Client Libraries
Task 1 – Opening the Begin Solution and Exploring the Common Functionalities
Task 2 – Connecting to SQL Azure Using ADO.NET
Task 3 – Connecting to SQL Azure Using ODBC
Task 4 – Connecting to SQL Azure Using OLEDB
Task 5 – Connecting to SQL Azure Using Entity Framework
Task 6 – Connecting to SQL Azure via Non-Microsoft Technologies
Summary
